
SET IDENTITY_INSERT ShippingOptions ON
INSERT ShippingOptions ([Id], [Name], [PriceAmount]) VALUES (1, 'One-day shipping', 10.00)
INSERT ShippingOptions ([Id], [Name], [PriceAmount]) VALUES (2, 'Two-day shipping', 5.00)
INSERT ShippingOptions ([Id], [Name], [PriceAmount]) VALUES (3, 'Three-day shipping', 3.00)
SET IDENTITY_INSERT ShippingOptions OFF

SET IDENTITY_INSERT [Users] ON
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (1, N'syed@example.com', NULL, N'Abbas', N'Syed', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (2, N'catherine@example.com', NULL, N'Abel', N'Catherine', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (3, N'kim@example.com', NULL, N'Abercrombie', N'Kim', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (4, N'hazem@example.com', NULL, N'Abolrous', N'Hazem', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (5, N'sam@example.com', NULL, N'Abolrous', N'Sam', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (6, N'humberto@example.com', NULL, N'Acevedo', N'Humberto', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (7, N'gustavo@example.com', NULL, N'Achong', N'Gustavo', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (8, N'pilar@example.com', NULL, N'Ackerman', N'Pilar', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (9, N'aaron@example.com', NULL, N'Adams', N'Aaron', N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', NULL, NULL, 0)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (101, N'abikestore@example.com', N'A Bike Store', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'Seattle''s best location for everything about bikes.  We have what you need with the price and service that you will love.', 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (102, N'progressivesports@example.com', N'Progressive Sports', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'Progressive is not just a name, it''s a philosophy.  We specialize in biodegradable parts.', 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (103, N'abc@example.com', N'Advanced Bike Components', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'We have the parts that the pros use.  Why settle for consumer parts when you can have pro parts for the same prices?', 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (104, N'mcs@example.com', N'Modular Cycle Systems', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'It''s like building your bike from Legos!', 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (105, N'mss@example.com', N'Metropolitan Sports Supply', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'We exist for the bike commuter.  We have everything you need.', 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (106, N'aec@example.com', N'Aerobic Exercise Company', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', NULL, 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (107, N'ab@example.com', N'Associated Bikes', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', NULL, 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (108, N'ec@example.com', N'Exemplary Cycles', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'', 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (109, N'tbs@example.com', N'Tandem Bicycle Store', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'For eveything about bicycles made for two.', 1)
INSERT [dbo].[Users] ([Id], [Email], [Name], [LastName], [FirstName], [PasswordHash], [PasswordSalt], [ApiKey], [Description], [UserTypeId]) VALUES (110, N'rce@example.com', N'Rural Cycle Emporium', NULL, NULL, N'8B456CB2053E30E3BC72FC7BE2F192057B7FACB10179DA22214E0A960E4189CB', N'D552C3BBB34239160890627A0B8F65490E9DBCB80246EAF21C72FFB5770D84C7', N'Password1', N'If you need to ride gravel roads in Iowa, then we got your stuff!', 1)
SET IDENTITY_INSERT [Users] OFF

SET IDENTITY_INSERT [States] ON
INSERT [States] ([Id], [Name]) VALUES (1, N'Alabama')
INSERT [States] ([Id], [Name]) VALUES (2, N'Alaska')
INSERT [States] ([Id], [Name]) VALUES (3, N'Arizona')
INSERT [States] ([Id], [Name]) VALUES (4, N'Arkansas')
INSERT [States] ([Id], [Name]) VALUES (5, N'California')
INSERT [States] ([Id], [Name]) VALUES (6, N'Colorado')
INSERT [States] ([Id], [Name]) VALUES (7, N'Connecticut')
INSERT [States] ([Id], [Name]) VALUES (8, N'Delaware')
INSERT [States] ([Id], [Name]) VALUES (9, N'District of Columbia')
INSERT [States] ([Id], [Name]) VALUES (10, N'Florida')
INSERT [States] ([Id], [Name]) VALUES (11, N'Georgia')
INSERT [States] ([Id], [Name]) VALUES (12, N'Hawaii')
INSERT [States] ([Id], [Name]) VALUES (13, N'Idaho')
INSERT [States] ([Id], [Name]) VALUES (14, N'Illinois')
INSERT [States] ([Id], [Name]) VALUES (15, N'Indiana')
INSERT [States] ([Id], [Name]) VALUES (16, N'Iowa')
INSERT [States] ([Id], [Name]) VALUES (17, N'Kansas')
INSERT [States] ([Id], [Name]) VALUES (18, N'Kentucky')
INSERT [States] ([Id], [Name]) VALUES (19, N'Louisiana')
INSERT [States] ([Id], [Name]) VALUES (20, N'Maine')
INSERT [States] ([Id], [Name]) VALUES (21, N'Maryland')
INSERT [States] ([Id], [Name]) VALUES (22, N'Massachusetts')
INSERT [States] ([Id], [Name]) VALUES (23, N'Michigan')
INSERT [States] ([Id], [Name]) VALUES (24, N'Minnesota')
INSERT [States] ([Id], [Name]) VALUES (25, N'Mississippi')
INSERT [States] ([Id], [Name]) VALUES (26, N'Missouri')
INSERT [States] ([Id], [Name]) VALUES (27, N'Montana')
INSERT [States] ([Id], [Name]) VALUES (28, N'Nebraska')
INSERT [States] ([Id], [Name]) VALUES (29, N'Nevada')
INSERT [States] ([Id], [Name]) VALUES (30, N'New Hampshire')
INSERT [States] ([Id], [Name]) VALUES (31, N'New Jersey')
INSERT [States] ([Id], [Name]) VALUES (32, N'New Mexico')
INSERT [States] ([Id], [Name]) VALUES (33, N'New York')
INSERT [States] ([Id], [Name]) VALUES (34, N'North Carolina')
INSERT [States] ([Id], [Name]) VALUES (35, N'North Dakota')
INSERT [States] ([Id], [Name]) VALUES (36, N'Ohio')
INSERT [States] ([Id], [Name]) VALUES (37, N'Oklahoma')
INSERT [States] ([Id], [Name]) VALUES (38, N'Oregon')
INSERT [States] ([Id], [Name]) VALUES (39, N'Pennsylvania')
INSERT [States] ([Id], [Name]) VALUES (40, N'Rhode Island and Providence Plantations')
INSERT [States] ([Id], [Name]) VALUES (41, N'South Carolina')
INSERT [States] ([Id], [Name]) VALUES (42, N'South Dakota')
INSERT [States] ([Id], [Name]) VALUES (43, N'Tennessee')
INSERT [States] ([Id], [Name]) VALUES (44, N'Texas')
INSERT [States] ([Id], [Name]) VALUES (45, N'Utah')
INSERT [States] ([Id], [Name]) VALUES (46, N'Vermont')
INSERT [States] ([Id], [Name]) VALUES (47, N'Virginia')
INSERT [States] ([Id], [Name]) VALUES (48, N'Washington')
INSERT [States] ([Id], [Name]) VALUES (49, N'West Virginia')
INSERT [States] ([Id], [Name]) VALUES (50, N'Wisconsin')
INSERT [States] ([Id], [Name]) VALUES (51, N'Wyoming')
SET IDENTITY_INSERT [States] OFF
SET IDENTITY_INSERT [Products] ON
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (1, N'Adjustable Race', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (2, N'All-Purpose Bike Stand', N'Perfect all-purpose bike stand for working on your bike at home. Quick-adjusting clamps and steel construction.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (3, N'AWC Logo Cap', N'Traditional style with a flip-up brim; one-size fits all.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (4, N'BB Ball Bearing', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (5, N'Bearing Ball', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (6, N'Bike Wash - Dissolver', N'Washes off the toughest road grime; dissolves grease, environmentally safe. 1-liter bottle.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (7, N'Blade', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (8, N'Cable Lock', N'Wraps to fit front and rear tires, carrier and 2 keys included.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (9, N'Chain', N'Superior shifting performance.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (10, N'Chain Stays', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (11, N'Chainring', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (12, N'Chainring Bolts', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (13, N'Chainring Nut', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (14, N'Classic Vest, L', N'Light-weight, wind-resistant, packs to fit into a pocket.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (15, N'Classic Vest, M', N'Light-weight, wind-resistant, packs to fit into a pocket.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (16, N'Classic Vest, S', N'Light-weight, wind-resistant, packs to fit into a pocket.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (17, N'Cone-Shaped Race', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (18, N'Crown Race', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (19, N'Cup-Shaped Race', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (20, N'Decal 1', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (21, N'Decal 2', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (22, N'Down Tube', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (23, N'External Lock Washer 1', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (24, N'External Lock Washer 2', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (25, N'External Lock Washer 3', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (26, N'External Lock Washer 4', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (27, N'External Lock Washer 5', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (28, N'External Lock Washer 6', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (29, N'External Lock Washer 7', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (30, N'External Lock Washer 8', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (31, N'External Lock Washer 9', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (32, N'Fender Set - Mountain', N'Clip-on fenders fit most mountain bikes.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (33, N'Flat Washer 1', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (34, N'Flat Washer 2', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (35, N'Flat Washer 3', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (36, N'Flat Washer 4', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (37, N'Flat Washer 5', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (38, N'Flat Washer 6', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (39, N'Flat Washer 7', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (40, N'Flat Washer 8', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (41, N'Flat Washer 9', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (42, N'Fork Crown', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (43, N'Fork End', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (44, N'Freewheel', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (45, N'Front Brakes', N'All-weather brake pads; provides superior stopping by applying more surface to the rim.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (46, N'Front Derailleur', N'Wide-link design.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (47, N'Front Derailleur Cage', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (48, N'Front Derailleur Linkage', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (49, N'Full-Finger Gloves, L', N'Synthetic palm, flexible knuckles, breathable mesh upper. Worn by the AWC team riders.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (50, N'Full-Finger Gloves, M', N'Synthetic palm, flexible knuckles, breathable mesh upper. Worn by the AWC team riders.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (51, N'Full-Finger Gloves, S', N'Synthetic palm, flexible knuckles, breathable mesh upper. Worn by the AWC team riders.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (52, N'Guide Pulley', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (53, N'Half-Finger Gloves, L', N'Full padding, improved finger flex, durable palm, adjustable closure.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (54, N'Half-Finger Gloves, M', N'Full padding, improved finger flex, durable palm, adjustable closure.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (55, N'Half-Finger Gloves, S', N'Full padding, improved finger flex, durable palm, adjustable closure.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (56, N'Handlebar Tube', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (57, N'Head Tube', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (58, N'Headlights - Dual-Beam', N'Rechargeable dual-beam headlight.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (59, N'Headlights - Weatherproof', N'Rugged weatherproof headlight.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (60, N'Headset Ball Bearings', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (61, N'Hex Nut 1', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (62, N'Hex Nut 10', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (63, N'Hex Nut 11', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (64, N'Hex Nut 12', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (65, N'Hex Nut 13', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (66, N'Hex Nut 14', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (67, N'Hex Nut 15', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (68, N'Hex Nut 16', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (69, N'Hex Nut 17', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (70, N'Hex Nut 18', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (71, N'Hex Nut 19', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (72, N'Hex Nut 2', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (73, N'Hex Nut 20', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (74, N'Hex Nut 21', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (75, N'Hex Nut 22', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (76, N'Hex Nut 23', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (77, N'Hex Nut 3', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (78, N'Hex Nut 4', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (79, N'Hex Nut 5', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (80, N'Hex Nut 6', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (81, N'Hex Nut 7', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (82, N'Hex Nut 8', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (83, N'Hex Nut 9', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (84, N'Hitch Rack - 4-Bike', N'Carries 4 bikes securely; steel construction, fits 2" receiver hitch.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (85, N'HL Bottom Bracket', N'Aluminum alloy cups and a hollow axle.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (86, N'HL Crankarm', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (87, N'HL Crankset', N'Triple crankset; alumunim crank arm; flawless shifting.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (88, N'HL Fork', N'High-performance carbon road fork with curved legs.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (89, N'HL Grip Tape', NULL)
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (90, N'HL Headset', N'High-quality 1" threadless headset with a grease port for quick lubrication.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (97, N'HL Mountain Frame - Silver, 38', N'A new description at 16:44')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (98, N'HL Mountain Frame - Silver, 42', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (99, N'HL Mountain Frame - Silver, 44', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (100, N'HL Mountain Frame - Silver, 46', N'Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (110, N'A New Row', N'Added to the table at 19:04')
INSERT [dbo].[Products] ([Id], [Name], [Description]) VALUES (111, N'A New Row', N'Added to the table at 16:44')
SET IDENTITY_INSERT [Products] OFF
GO

SET IDENTITY_INSERT [Offerings] ON
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (1, 101, 1, 11.0000, 35, 1, N'This is an awesome product.  Everybody in the store uses these.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (2, 101, 2, 190.0000, 15, 1, N'Super product.  No more bikes falling over!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (3, 101, 3, 158.0000, 4, 1, N'You will look so cool wearing this cap!  Buy them for your friends and family as well.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (4, 101, 4, 296.0000, 36, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (5, 101, 5, 364.0000, 18, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (6, 101, 6, 126.0000, 14, 1, N'Why not try this for washing dishes?  It really cuts through baked on lasagna.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (7, 101, 7, 79.0000, 12, 1, N'Sharp.  Very sharp.  Please be careful.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (8, 101, 8, 197.0000, 30, 1, N'For casual use only--won''t stop the determined thief.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (9, 101, 9, 108.0000, 20, 1, N'Make sure you change yours every 3000 miles.  Don''t get stuck half way up a 25% logging road in Oregon with a broken one!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (10, 101, 10, 441.0000, 16, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (11, 101, 11, 213.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (12, 101, 12, 13.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (13, 101, 13, 319.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (14, 101, 14, 246.0000, 3, 1, N'We stock super-small sizes for your kids!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (15, 101, 15, 416.0000, 3, 1, N'Great to wear at work...if you work in a bike shop.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (16, 101, 16, 128.0000, 3, 1, N'Please check your size before buying.  One size doesn''t fit some.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (17, 101, 17, 330.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (18, 101, 18, 11.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (19, 101, 19, 190.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (20, 101, 20, 158.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (21, 101, 21, 296.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (22, 101, 22, 364.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (23, 101, 23, 126.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (24, 101, 24, 79.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (25, 101, 25, 197.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (26, 102, 1, 12.0000, 35, 1, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (27, 102, 2, 2000.0000, 15, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (28, 102, 3, 150.0000, 4, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (29, 102, 4, 286.0000, 36, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (30, 102, 5, 374.0000, 18, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (31, 102, 6, 136.0000, 14, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (32, 102, 7, 69.0000, 12, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (33, 102, 8, 187.0000, 30, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (34, 102, 9, 118.0000, 20, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (35, 102, 10, 451.0000, 16, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (36, 102, 11, 203.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (37, 102, 12, 12.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (38, 102, 13, 329.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (39, 102, 14, 246.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (40, 102, 15, 416.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (41, 102, 16, 128.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (42, 102, 17, 330.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (43, 102, 18, 21.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (44, 102, 19, 191.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (45, 102, 20, 168.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (46, 102, 21, 286.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (47, 102, 22, 354.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (48, 102, 23, 116.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (49, 102, 24, 69.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (50, 102, 25, 187.0000, 3, 0, N'Find a better price and we''ll refund the difference!')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (51, 103, 1, 12.0000, 35, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (52, 103, 3, 2000.0000, 15, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (53, 103, 5, 150.0000, 4, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (54, 103, 7, 286.0000, 36, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (55, 103, 9, 374.0000, 18, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (56, 103, 11, 136.0000, 14, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (57, 103, 13, 69.0000, 12, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (58, 103, 15, 187.0000, 30, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (59, 103, 17, 118.0000, 20, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (60, 103, 19, 451.0000, 16, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (61, 103, 21, 203.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (62, 103, 23, 12.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (63, 103, 25, 329.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (64, 103, 27, 246.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (65, 103, 29, 416.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (66, 103, 31, 128.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (67, 103, 33, 330.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (68, 103, 35, 21.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (69, 103, 37, 191.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (70, 103, 39, 168.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (71, 103, 41, 286.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (72, 103, 42, 354.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (73, 103, 43, 116.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (74, 103, 44, 69.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (75, 103, 45, 187.0000, 3, 0, N'We have the best service on the west coast, guaranteed.')
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (76, 104, 1, 13.0000, 35, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (77, 104, 3, 1990.0000, 15, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (78, 104, 5, 140.0000, 4, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (79, 104, 7, 266.0000, 36, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (80, 104, 9, 394.0000, 18, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (81, 104, 11, 156.0000, 14, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (82, 104, 13, 79.0000, 12, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (83, 104, 15, 167.0000, 30, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (84, 104, 17, 128.0000, 20, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (85, 104, 19, 461.0000, 16, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (86, 104, 21, 213.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (87, 104, 23, 13.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (88, 104, 25, 349.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (89, 104, 27, 226.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (90, 104, 29, 406.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (91, 104, 31, 138.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (92, 104, 33, 340.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (93, 104, 35, 26.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (94, 104, 37, 161.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (95, 104, 39, 198.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (96, 104, 41, 256.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (97, 104, 42, 384.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (98, 104, 43, 126.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (99, 104, 44, 69.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (100, 104, 45, 187.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (101, 105, 2, 12.0000, 35, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (102, 105, 4, 2000.0000, 15, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (103, 105, 6, 150.0000, 4, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (104, 105, 8, 286.0000, 36, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (105, 105, 10, 374.0000, 18, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (106, 105, 12, 136.0000, 14, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (107, 105, 14, 69.0000, 12, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (108, 105, 16, 187.0000, 30, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (109, 105, 18, 118.0000, 20, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (110, 105, 20, 451.0000, 16, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (111, 105, 22, 203.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (112, 105, 24, 12.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (113, 105, 26, 329.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (114, 105, 28, 246.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (115, 105, 30, 416.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (116, 105, 32, 128.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (117, 105, 34, 330.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (118, 105, 36, 21.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (119, 105, 38, 191.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (120, 105, 40, 168.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (121, 105, 42, 286.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (122, 105, 44, 354.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (123, 105, 46, 116.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (124, 105, 48, 69.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (125, 105, 50, 187.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (126, 106, 2, 12.0000, 35, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (127, 106, 4, 2000.0000, 15, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (128, 106, 6, 150.0000, 4, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (129, 106, 8, 286.0000, 36, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (130, 106, 10, 374.0000, 18, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (131, 106, 12, 136.0000, 14, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (132, 106, 14, 69.0000, 12, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (133, 106, 16, 187.0000, 30, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (134, 106, 18, 118.0000, 20, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (135, 106, 20, 451.0000, 16, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (136, 106, 22, 203.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (137, 106, 24, 12.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (138, 106, 26, 329.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (139, 106, 28, 246.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (140, 106, 30, 416.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (141, 106, 32, 128.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (142, 106, 34, 330.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (143, 106, 36, 21.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (144, 106, 38, 191.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (245, 106, 40, 168.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (246, 106, 42, 286.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (247, 106, 44, 354.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (248, 106, 46, 116.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (249, 106, 48, 69.0000, 3, 0, NULL)
INSERT [dbo].[Offerings] ([Id], [RetailerId], [ProductId], [PriceAmount], [Quantity], [IsFeatured], [Comments]) VALUES (250, 106, 50, 187.0000, 3, 0, NULL)
SET IDENTITY_INSERT [Offerings] OFF

GO

SET IDENTITY_INSERT [Orders] ON
INSERT [dbo].[Orders] ([Id], [CustomerId], [Status], [CreatedOn], [CreditCardName], [CreditCardNumber], [CreditCardExpiryMonth], [CreditCardExpiryYear], [ShipStreet], [ShipCity], [ShipStateId], [ShipZipCode], [ShippingOptionId], [BillStreet], [BillCity], [BillStateId], [BillZipCode]) VALUES (1, 1, N'DRAFT', CAST(0x00009BA300B89908 AS DateTime), N'VISA', N'1234567890123456', N'9 ', N'10', N'123 Elm Street', N'Denver', 6, N'12345', 2, N'123 Pine Street', N'Seattle', 48, N'98765')
INSERT [dbo].[Orders] ([Id], [CustomerId], [Status], [CreatedOn], [CreditCardName], [CreditCardNumber], [CreditCardExpiryMonth], [CreditCardExpiryYear], [ShipStreet], [ShipCity], [ShipStateId], [ShipZipCode], [ShippingOptionId], [BillStreet], [BillCity], [BillStateId], [BillZipCode]) VALUES (2, 2, N'DRAFT', CAST(0x00009BA50013CD88 AS DateTime), N'VISA', N'1234567890123456', N'9 ', N'10', N'321 Cedar Court', N'Denver', 6, N'12345', 1, N'123 Willow Lane', N'Seattle', 48, N'12345')
INSERT [dbo].[Orders] ([Id], [CustomerId], [Status], [CreatedOn], [CreditCardName], [CreditCardNumber], [CreditCardExpiryMonth], [CreditCardExpiryYear], [ShipStreet], [ShipCity], [ShipStateId], [ShipZipCode], [ShippingOptionId], [BillStreet], [BillCity], [BillStateId], [BillZipCode]) VALUES (3, 1, N'BILLED', CAST(0x00009BA70034C308 AS DateTime), NULL, NULL, NULL, NULL, N'555 East Street', N'Bangor', 20, N'55555', 3, NULL, NULL, NULL, NULL)
INSERT [dbo].[Orders] ([Id], [CustomerId], [Status], [CreatedOn], [CreditCardName], [CreditCardNumber], [CreditCardExpiryMonth], [CreditCardExpiryYear], [ShipStreet], [ShipCity], [ShipStateId], [ShipZipCode], [ShippingOptionId], [BillStreet], [BillCity], [BillStateId], [BillZipCode]) VALUES (4, 2, N'DRAFT', CAST(0x00009BA90055B888 AS DateTime), N'VISA', N'1234567890123456', N'7 ', N'11', N'888 Main Street', N'New York', 33, N'54321', 3, NULL, NULL, NULL, NULL)
INSERT [dbo].[Orders] ([Id], [CustomerId], [Status], [CreatedOn], [CreditCardName], [CreditCardNumber], [CreditCardExpiryMonth], [CreditCardExpiryYear], [ShipStreet], [ShipCity], [ShipStateId], [ShipZipCode], [ShippingOptionId], [BillStreet], [BillCity], [BillStateId], [BillZipCode]) VALUES (5, 3, N'DRAFT', CAST(0x00009BAB0076AE08 AS DateTime), N'VISA', N'1234567890123456', N'4 ', N'12', N'Tower Court', N'Los Angeles', 5, N'54321', 2, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [Orders] OFF

GO

SET IDENTITY_INSERT [OrderLines] ON
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (1, 1, 2, 1, N'0123456789', 1)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (2, 1, 2, 2, NULL, 0)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (3, 1, 21, 3, NULL, 0)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (4, 2, 2, 1, N'1234567890', 1)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (5, 2, 2, 2, NULL, 0)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (6, 2, 21, 3, NULL, 0)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (7, 3, 26, 3, NULL, 0)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (8, 3, 27, 3, NULL, 0)
INSERT [dbo].[OrderLines] ([Id], [OrderId], [OfferingId], [Quantity], [TrackingNumber], [HasShipped]) VALUES (9, 3, 28, 3, NULL, 0)
SET IDENTITY_INSERT [OrderLines] OFF

SET IDENTITY_INSERT [CartItems] ON
INSERT [dbo].[CartItems] ([Id], [CustomerId], [OfferingId], [Quantity]) VALUES (1, 2, 11, 1)
INSERT [dbo].[CartItems] ([Id], [CustomerId], [OfferingId], [Quantity]) VALUES (2, 2, 12, 2)
INSERT [dbo].[CartItems] ([Id], [CustomerId], [OfferingId], [Quantity]) VALUES (3, 3, 8, 1)
SET IDENTITY_INSERT [CartItems] OFF
